<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Untitled Document</title>
</head>

<body>
<h2 class="title-list">Newest Products </h2> 
<div>
<?php
// 10 sản phẩm mới nhất
$query = "select * from sanpham order by NgayNhap limit 0,9";
$result = DataProvider::ExecuteQuery($query);
$newest= new paginator();
$newest::display($result);
?>
</div>
<div>&nbsp;</div>
<div style="clear:both;" class="title-list">
<h2>Best Sale  Products </h2> 
<?php
// 10 sản phẩm bán chạy nhất
$query2 = "select * from sanpham order by SoLuongBan limit 0,9";
$result2 = DataProvider::ExecuteQuery($query2);
$bestsale = new paginator();
$bestsale::display($result2);
?>
</div>
</body>
</html>
